package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.Dept;

public interface IDeptDAO extends CrudRepository<Dept, Long> {
	@Query("select new Dept(d.deptno, d.dname, d.loc) from Dept d")
	public List<Dept> findAllDepts();
}
